
/*
*Pool Public Licence version 0.1 or later
*Released on 20th April 2008.
*Any voilations can be repoted at paritosh@wikiocean.net
*What is treated as voilations can be found at www.wikiocean.net/ppl1-voilations* 
******************************************************************************
* The contents of this file are subject Affero GPL v3 and later with additional conditions.
* The additional conditions are to be considered as part of the Affero GPL v3 and later.
* The additional conditions will supersede the Affero GPLv3 and later in case of conflict.
* ("License"); You may not use this file except in compliance with the License
* You may obtain a copy of the License at http://www.gnu.org/licenses/agpl.html
* Software distributed under the License is distributed on an "AS IS" basis,
* WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License for
* the specific language governing rights and limitations under the License.
* The Initial Developer of the Original Code is Paritosh Pungaliya.
* created by Paritosh Pungaliya are Copyright (C) Paritosh Pungaliya; All Rights Reserved.
* Contributions are Copyright (C) 2001-2008 Paritosh Pungaliya.

* Objective of the additional terms (license) 
* 1) Is to extend the software freedom to freedom to work.
* 2) To ensure that knowledge is free from monopoly of agencie(s).
* 3) To avoid a situation where big corporates or investors can buy out free software groups and companies and then start milking the communities built around it.
* (this trend can be seen how the openness changes in companies that get Venture Capital funding.)
* (if you agree to this logic I invite you to our group to work together)

* Additional conditions
*  0) Source code will also include
* 	a) data dictionaries, data ontologies which are used to alter the behavior of code or to control           the features of application.
* 	b) Any code generated or derived automatically or manually from this code or logic
*  1) The revenue generated by deploying, implementing , selling services and other activities
*  	 based on this source code should be shared 100%, between the people working on it.
*  2) Capital invested should be given only fixed rate of return or linked to revenue/surplus growth for limited time.
*  3) People working on the project should always have an option to replace the capital provider in full or part with lower cost capital.
*  4) Their should not be any ownership which can be sold as a claim on future profit to be generated from the work of people working on the code.
*  5) Brand thus generated should belong to the group.
*  6) For old and new members revenue sharing should be equal for same work equivalent.
*  7) The share of revenue should be decided by bidding for work before allocation of work within the group.
*  8) Before bidding various method of measuring the work should be clearly defined and published in public domain. Any change in process should also be publised in public domain imediately.
*  9) All data related to to revenue sharing should be published as and when generated in public domain.
*  10) For group of people having size more than 10 people will have to make it open online for others to participate in bids. 
*  11) All people involved in related and sub project will be treated as a group.
*  12) Once this license is being used for a certain code then all and any other software services being provided by the group should complusorilly come under 100% revenue sharing.
*  13) Cross subsidization should not happen under this revenue share, no additional benefit should be drawn from the people, by the employing agency.
*  14) Any position or knowledge or legal structure created relating to people working on code, which adversely affects the spirit of 100% revenue share will be treated as a violation.
*  15) Revenue sharing defined.
*     a) includes direct revenue and also intangible gains like brand, and organization.
*     b) No personal judgment should be involved in judging the distribution of revenue.It has to be pre-defined formula based.
*     c)100% of revenue should be shared before expenses and recievers should have control over what expenses to incur.
*     d)For the work done in any month by contributing group member, working on any project can be given revenue share from the work done by the group, for a maximum of 18 months after that month.
*     e)Revenue should be apportioned to the month in which work is done and not when received.
*  The group fulfilling the above conditions also has to be a wiki ecosystem further defined in www.wekosystem.org or read about Wekosystem at www.wikiocean.net

*  ******************************************************************************
*/  
package calculation;

import java.util.Hashtable;

import operations.Operation;
import timer.ExecutionTimer;
import timer.TimerRecordFile;
import utility.ReadFile;
import control.SpecialCharacter;
import database.RecordSearch;
import dbmanager.Column;
import dbmanager.DBManager;
import dbmanager.GetIdName;

public class Expressionsubstring 
{
	String Operator = "Operation"; 
	DBManager dbSQL;
	SpecialCharacter cp;
	boolean FLAG = false;
	int beginIndex=0;
	int endIndex=0;
	String Result="";
	ReadFile rFile = new ReadFile();
	GetIdName gin; 
	Operation operation;
	
	String Right;
	String Left;
	
	Hashtable<Object,Object> TransactionMap = new Hashtable<Object,Object>(); 
	Hashtable<Object,Object>TransactionDetailMap =  new Hashtable<Object,Object>();
	
	Expressionsubstring(DBManager dbSQL, Hashtable<Object,Object> TransactionMap, Hashtable<Object,Object>TransactionDetailMap)
	{
		 ExecutionTimer t = new ExecutionTimer();
		 t.start();
		this.dbSQL = dbSQL;
		cp = new SpecialCharacter();
		gin = new GetIdName(dbSQL);
		
		this.TransactionMap.putAll(TransactionMap);
		this.TransactionDetailMap.putAll(TransactionDetailMap);
		t.end();
		TimerRecordFile timerFile=new TimerRecordFile("calculation","Expressionsubstring","Expressionsubstring",t.duration());
	}
	
	public String getResult(String expression, String [] RecordSet) 
	{
		 ExecutionTimer t = new ExecutionTimer();
		 t.start();
		String path = rFile.getMasterReportPath();
		String copyExpression = expression;
		for(int i= 0;i<RecordSet.length;i++)
		{
			if(expression.contains(RecordSet[i]))
			{
				int index = expression.indexOf(RecordSet[i]);
				
				int begin = cp.getPrevSpChar(index, expression.toCharArray());
				
				if(begin==-1) 
					begin++;
				beginIndex = begin;
				Left = expression.substring(begin,index);
				try
				{
					FLAG = true;
					Double.parseDouble(Left);
					Left = expression.substring(begin,index);
				}
				catch (Exception e) 
				{
					FLAG = false;
				}
				if(FLAG == false)
				{
					Left = Left.substring(1);
					int tabbegin = cp.getPrevSpChar(begin, expression.toCharArray());
					if(tabbegin==-1) 
						tabbegin++;
					String LeftTable = expression.substring(tabbegin,begin);
					
					System.out.println("calculation::Expressionsubstring::getResult():Left : "+Left);
					System.out.println("calculation::Expressionsubstring::getResult():LeftTable : "+LeftTable);
					beginIndex = tabbegin;
					
					if(LeftTable.equals("transaction_details"))
						Left = TransactionDetailMap.get(Left.toLowerCase()).toString();
					else if(LeftTable.equals("transaction"))
						Left = TransactionMap.get(Left.toLowerCase()).toString();
					System.out.println("calculation::Expressionsubstring::getResult():LeftValue : "+Left);
				}
				
				int tabbegin = cp.getNextSpChar(index, expression.toCharArray());
				String RightTable = expression.substring(index+1,tabbegin);
				endIndex = tabbegin;
				
				try
				{
					FLAG = true;
					Double.parseDouble(RightTable);
					Right = RightTable;
				}
				catch (Exception e) 
				{
					FLAG = false;
				}
				if(FLAG == false)
				{
					int end = cp.getNextSpChar(tabbegin, expression.toCharArray());
					Right = expression.substring(tabbegin+1,end);
					
					System.out.println("calculation::Expressionsubstring::getResult():RightTable : "+RightTable);
					System.out.println("calculation::Expressionsubstring::getResult():Right : "+Right);
					endIndex = end;
					if(RightTable.equals("transaction_details"))
						Right = TransactionDetailMap.get(Right.toLowerCase()).toString();
					else if(RightTable.equals("transaction"))
						Right = TransactionMap.get(Right.toLowerCase()).toString(); 
					System.out.println("calculation::Expressionsubstring::getResult():RightValue : "+Right);
				}
				
				//CALL OPERATIONS
				
				//Get CLASS NAME FROM THE OPERATOR
				String operator_id = gin.getId(Operator);
				RecordSearch rs =new RecordSearch(dbSQL); 
				Hashtable<Object, Object> table =new Hashtable<Object, Object>();
				table.put("td", "null");
				table.put("mid", operator_id);
				rs.setConditionMap(table);
				String record = rFile.searchObject(rs.getArrayFromResultSet(),gin.getId(RecordSet[i]));
				if(record.equals("error"))
					return "error";
				else
				{
					String temp [] = record.split("\t");
					
					//Get ORDER OF VALUE TEXT
					try
					{
						//RandomAccessFile raf = new RandomAccessFile(path,"r");
						//FileUtility file = new FileUtility(raf);
						//int VTOrder =file.getColumnIndex("VT")-1;
						int VTOrder = Column.vt_index-1;
						operator_id = temp[VTOrder];
						Class c = Class.forName("operations."+operator_id);
						operation = (Operation) c.newInstance();
						expression = operation.operation(Left, Right);
					}
					catch (ClassNotFoundException e) 
					{	
						System.out.println("calculation::Expressionsubstring::getResult():Exception -> Class Not Found : "+operator_id);
					} catch (InstantiationException e) {
						e.printStackTrace();
					} catch (IllegalAccessException e) {
						e.printStackTrace();
					} 
					
				}
			}
		}
		//System.out.println("calculation::Expressionsubstring::getResult():beginIndex : "+beginIndex);
		//System.out.println("calculation::Expressionsubstring::getResult():endIndex : "+endIndex);
		if(expression.equals(copyExpression))
		{
			return "error";
		}
		if(copyExpression.length() != endIndex)
		{
			StringBuffer temp = new StringBuffer(copyExpression);
			temp.replace(beginIndex, endIndex, expression);
			expression = getResult(temp.toString(), RecordSet);
		}
		try
		{
			Double.parseDouble(expression);
			return expression;
		}
		catch (Exception e) 
		{
			e.printStackTrace();
		}
		
		System.out.println("calculation::Expressionsubstring::getResult():Result is : "+Result);
		
		 t.end();
			TimerRecordFile timerFile=new TimerRecordFile("calculation","Expressionsubstring","getResult",t.duration());
		return expression;
	}
}
